A database trigger is a stored procedure that is invoked automatically when a predefined event occurs.

check this article ...
http://www.mindstick.com/Articles/8a50890e-16b5-4fc6-8970-54ae61a898f9/default.aspx?Triggers+in+SQL+Server